--
-- PostgreSQL database dump
--

-- Dumped from database version 10.5
-- Dumped by pg_dump version 10.5

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: DATABASE postgres; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON DATABASE postgres IS 'default administrative connection database';


--
-- Name: timescaledb; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS timescaledb WITH SCHEMA public;


--
-- Name: EXTENSION timescaledb; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION timescaledb IS 'Enables scalable inserts and complex queries for time-series data';


--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


--
-- Name: adminpack; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS adminpack WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION adminpack; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION adminpack IS 'administrative functions for PostgreSQL';


--
-- Name: uuid-ossp; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA public;


--
-- Name: EXTENSION "uuid-ossp"; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION "uuid-ossp" IS 'UUID扩展';


--
-- Name: insertbatch(integer); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.insertbatch(x integer) RETURNS void
    LANGUAGE plpgsql
    AS $$declare

	i int;

	begin

	i:=1;

		for i in 1..x loop

		 insert into conditions (time, location, temp,timet) values (Now(),'wuhan',22.1,'aa');

		 insert into table1 (time,location) values (Now(),'wuhan');

		 insert into table2 (time,temp) values (Now(),22.2);

		 insert into table3 (time,abc) values (Now(),22.2);

		 insert into table4 (time,us) values (Now(),22.2);

		 insert into table5 (time,abc) values (Now(),'aa');

		 insert into table6 (time,abc) values (Now(),'aa');

		 insert into table7 (time,abc) values (Now(),'ab');

		 insert into table8 (time,abc) values (Now(),'ab');

		 insert into table9 (time,abc) values (Now(),'ab');

		end loop;

		

	end;

$$;


ALTER FUNCTION public.insertbatch(x integer) OWNER TO postgres;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: dict; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.dict (
    id bigint NOT NULL,
    dict_category character varying(50) DEFAULT ''::character varying,
    code character varying(1000) DEFAULT ''::character varying,
    name character varying(300) DEFAULT ''::character varying,
    dict_description text DEFAULT ''::character varying,
    parent_id bigint,
    create_time timestamp without time zone,
    update_time timestamp without time zone,
    order_no integer DEFAULT 0
);


ALTER TABLE public.dict OWNER TO postgres;

--
-- Name: TABLE dict; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.dict IS '字典';


--
-- Name: COLUMN dict.id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.dict.id IS '主键';


--
-- Name: COLUMN dict.dict_category; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.dict.dict_category IS '字典大类';


--
-- Name: COLUMN dict.code; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.dict.code IS '键';


--
-- Name: COLUMN dict.name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.dict.name IS '值';


--
-- Name: COLUMN dict.dict_description; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.dict.dict_description IS '描述';


--
-- Name: COLUMN dict.parent_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.dict.parent_id IS '所属父类';


--
-- Name: COLUMN dict.create_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.dict.create_time IS '创建时间';


--
-- Name: COLUMN dict.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.dict.update_time IS '更新时间';


--
-- Name: COLUMN dict.order_no; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.dict.order_no IS '序号';


--
-- Name: dict_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.dict_id_seq
    START WITH 2000
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.dict_id_seq OWNER TO postgres;

--
-- Name: dict_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.dict_id_seq OWNED BY public.dict.id;


--
-- Name: iot_button; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_button (
    button_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    menu_id uuid,
    button_name character varying(50),
    button_control_id character varying(50),
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_button OWNER TO postgres;

--
-- Name: TABLE iot_button; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_button IS '按钮表';


--
-- Name: COLUMN iot_button.button_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_button.button_id IS '按钮ID';


--
-- Name: COLUMN iot_button.menu_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_button.menu_id IS '菜单ID';


--
-- Name: COLUMN iot_button.button_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_button.button_name IS '按钮名称';


--
-- Name: COLUMN iot_button.button_control_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_button.button_control_id IS '按钮控件ID';


--
-- Name: COLUMN iot_button.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_button.remarks IS '备注';


--
-- Name: COLUMN iot_button.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_button.creation_time IS '创建时间';


--
-- Name: COLUMN iot_button.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_button.creation_user IS '创建人';


--
-- Name: COLUMN iot_button.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_button.update_time IS '更新时间';


--
-- Name: COLUMN iot_button.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_button.update_user IS '更新人';


--
-- Name: COLUMN iot_button.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_button.spare1 IS '备用1';


--
-- Name: COLUMN iot_button.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_button.spare2 IS '备用2';


--
-- Name: COLUMN iot_button.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_button.spare3 IS '备用3';


--
-- Name: iot_collection_mode; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_collection_mode (
    collection_mode_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    collection_mode_name character varying(50),
    collection_mode_version character varying(50),
    collection_mode_serial_num integer,
    collection_mode_status character varying(10),
    collection_mode_type character varying(10),
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_collection_mode OWNER TO postgres;

--
-- Name: TABLE iot_collection_mode; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_collection_mode IS '采集方式表';


--
-- Name: COLUMN iot_collection_mode.collection_mode_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_mode.collection_mode_id IS '采集方式Id';


--
-- Name: COLUMN iot_collection_mode.collection_mode_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_mode.collection_mode_name IS '采集方式名称';


--
-- Name: COLUMN iot_collection_mode.collection_mode_version; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_mode.collection_mode_version IS '版本';


--
-- Name: COLUMN iot_collection_mode.collection_mode_serial_num; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_mode.collection_mode_serial_num IS '顺序号';


--
-- Name: COLUMN iot_collection_mode.collection_mode_status; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_mode.collection_mode_status IS '采集方式状态';


--
-- Name: COLUMN iot_collection_mode.collection_mode_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_mode.collection_mode_type IS '采集方式类型';


--
-- Name: COLUMN iot_collection_mode.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_mode.remarks IS '备注';


--
-- Name: COLUMN iot_collection_mode.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_mode.creation_time IS '创建时间';


--
-- Name: COLUMN iot_collection_mode.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_mode.creation_user IS '创建人';


--
-- Name: COLUMN iot_collection_mode.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_mode.update_time IS '更新时间';


--
-- Name: COLUMN iot_collection_mode.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_mode.update_user IS '更新人';


--
-- Name: COLUMN iot_collection_mode.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_mode.spare1 IS '备用1';


--
-- Name: COLUMN iot_collection_mode.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_mode.spare2 IS '备用2';


--
-- Name: COLUMN iot_collection_mode.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_mode.spare3 IS '备用3';


--
-- Name: iot_collection_point; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_collection_point (
    collection_point_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    equipment_collection_id uuid,
    collection_point_name character varying(50),
    collection_point_type character varying(10),
    collection_point_rate integer,
    collection_point_ip character varying(50),
    collection_point_data_type character varying(10),
    collection_point_data_process text,
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_collection_point OWNER TO postgres;

--
-- Name: TABLE iot_collection_point; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_collection_point IS '设备采集点';


--
-- Name: COLUMN iot_collection_point.collection_point_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.collection_point_id IS '采集点ID';


--
-- Name: COLUMN iot_collection_point.equipment_collection_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.equipment_collection_id IS '设备采集方式ID';


--
-- Name: COLUMN iot_collection_point.collection_point_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.collection_point_name IS '采集点名称';


--
-- Name: COLUMN iot_collection_point.collection_point_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.collection_point_type IS '采集点类型';


--
-- Name: COLUMN iot_collection_point.collection_point_rate; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.collection_point_rate IS '采集频率，单位毫秒';


--
-- Name: COLUMN iot_collection_point.collection_point_ip; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.collection_point_ip IS '采集点地址';


--
-- Name: COLUMN iot_collection_point.collection_point_data_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.collection_point_data_type IS '采集点数据类型';


--
-- Name: COLUMN iot_collection_point.collection_point_data_process; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.collection_point_data_process IS '数据处理';


--
-- Name: COLUMN iot_collection_point.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.remarks IS '备注';


--
-- Name: COLUMN iot_collection_point.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.creation_time IS '创建时间';


--
-- Name: COLUMN iot_collection_point.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.creation_user IS '创建人';


--
-- Name: COLUMN iot_collection_point.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.update_time IS '更新时间';


--
-- Name: COLUMN iot_collection_point.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.update_user IS '更新人';


--
-- Name: COLUMN iot_collection_point.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.spare1 IS '备用1';


--
-- Name: COLUMN iot_collection_point.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.spare2 IS '备用2';


--
-- Name: COLUMN iot_collection_point.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_collection_point.spare3 IS '备用3';


--
-- Name: iot_dictionary_item; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_dictionary_item (
    item_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    type_id uuid,
    itme_code character varying(50),
    itme_name character varying(50),
    itme_serial_num integer,
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_dictionary_item OWNER TO postgres;

--
-- Name: TABLE iot_dictionary_item; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_dictionary_item IS '数据字典项目表';


--
-- Name: COLUMN iot_dictionary_item.item_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_item.item_id IS '数据字典项目ID';


--
-- Name: COLUMN iot_dictionary_item.type_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_item.type_id IS '数据字典类型ID';


--
-- Name: COLUMN iot_dictionary_item.itme_code; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_item.itme_code IS '项目编码';


--
-- Name: COLUMN iot_dictionary_item.itme_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_item.itme_name IS '项目名称';


--
-- Name: COLUMN iot_dictionary_item.itme_serial_num; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_item.itme_serial_num IS '顺序号';


--
-- Name: COLUMN iot_dictionary_item.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_item.remarks IS '备注';


--
-- Name: COLUMN iot_dictionary_item.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_item.creation_time IS '创建时间';


--
-- Name: COLUMN iot_dictionary_item.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_item.creation_user IS '创建人';


--
-- Name: COLUMN iot_dictionary_item.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_item.update_time IS '更新时间';


--
-- Name: COLUMN iot_dictionary_item.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_item.update_user IS '更新人';


--
-- Name: COLUMN iot_dictionary_item.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_item.spare1 IS '备用1';


--
-- Name: COLUMN iot_dictionary_item.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_item.spare2 IS '备用2';


--
-- Name: COLUMN iot_dictionary_item.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_item.spare3 IS '备用3';


--
-- Name: iot_dictionary_type; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_dictionary_type (
    type_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    type_code character varying(50),
    type_name character varying(50),
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_dictionary_type OWNER TO postgres;

--
-- Name: TABLE iot_dictionary_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_dictionary_type IS '数据字典类型表';


--
-- Name: COLUMN iot_dictionary_type.type_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_type.type_id IS '数据字典类型ID';


--
-- Name: COLUMN iot_dictionary_type.type_code; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_type.type_code IS '类型编码';


--
-- Name: COLUMN iot_dictionary_type.type_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_type.type_name IS '类型名称';


--
-- Name: COLUMN iot_dictionary_type.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_type.remarks IS '备注';


--
-- Name: COLUMN iot_dictionary_type.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_type.creation_time IS '创建时间';


--
-- Name: COLUMN iot_dictionary_type.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_type.creation_user IS '创建人';


--
-- Name: COLUMN iot_dictionary_type.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_type.update_time IS '更新时间';


--
-- Name: COLUMN iot_dictionary_type.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_type.update_user IS '更新人';


--
-- Name: COLUMN iot_dictionary_type.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_type.spare1 IS '备用1';


--
-- Name: COLUMN iot_dictionary_type.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_type.spare2 IS '备用2';


--
-- Name: COLUMN iot_dictionary_type.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_dictionary_type.spare3 IS '备用3';


--
-- Name: iot_equipment; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_equipment (
    equipment_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    product_line_id uuid,
    equipment_type_id uuid,
    equipment_code character varying(50),
    equipment_name character varying(50),
    equipment_status character varying(10),
    equipment_ip character varying(50),
    equipment_start_time timestamp(0) without time zone,
    equipment_end_time timestamp(0) without time zone,
    gateway_id character varying(50),
    equipment_image character varying(100),
    equipment_manager character varying(50),
    equipment_brand character varying(50),
    equipment_supplier character varying(50),
    equipment_price numeric(18,2),
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(10),
    spare3 character varying(100)
);


ALTER TABLE public.iot_equipment OWNER TO postgres;

--
-- Name: TABLE iot_equipment; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_equipment IS '设备表';


--
-- Name: COLUMN iot_equipment.equipment_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.equipment_id IS '设备ID';


--
-- Name: COLUMN iot_equipment.product_line_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.product_line_id IS '产线ID';


--
-- Name: COLUMN iot_equipment.equipment_type_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.equipment_type_id IS '设备类型ID';


--
-- Name: COLUMN iot_equipment.equipment_code; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.equipment_code IS '设备编码';


--
-- Name: COLUMN iot_equipment.equipment_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.equipment_name IS '设备名称';


--
-- Name: COLUMN iot_equipment.equipment_status; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.equipment_status IS '设备状态';


--
-- Name: COLUMN iot_equipment.equipment_ip; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.equipment_ip IS '设备IP地址';


--
-- Name: COLUMN iot_equipment.equipment_start_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.equipment_start_time IS '开始日期';


--
-- Name: COLUMN iot_equipment.equipment_end_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.equipment_end_time IS '报废日期';


--
-- Name: COLUMN iot_equipment.gateway_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.gateway_id IS '连接网关ID';


--
-- Name: COLUMN iot_equipment.equipment_image; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.equipment_image IS '设备图片地址';


--
-- Name: COLUMN iot_equipment.equipment_manager; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.equipment_manager IS '责任人';


--
-- Name: COLUMN iot_equipment.equipment_brand; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.equipment_brand IS '品牌';


--
-- Name: COLUMN iot_equipment.equipment_supplier; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.equipment_supplier IS '供应商';


--
-- Name: COLUMN iot_equipment.equipment_price; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.equipment_price IS '设备价格';


--
-- Name: COLUMN iot_equipment.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.remarks IS '备注';


--
-- Name: COLUMN iot_equipment.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.creation_time IS '创建时间';


--
-- Name: COLUMN iot_equipment.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.creation_user IS '创建人';


--
-- Name: COLUMN iot_equipment.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.update_time IS '更新时间';


--
-- Name: COLUMN iot_equipment.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.update_user IS '更新人';


--
-- Name: COLUMN iot_equipment.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.spare1 IS '备用1';


--
-- Name: COLUMN iot_equipment.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.spare2 IS '备用2';


--
-- Name: COLUMN iot_equipment.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment.spare3 IS '备用3';


--
-- Name: iot_equipment_collection; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_equipment_collection (
    equipment_collection_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    equipment_id uuid,
    collection_mode_id uuid,
    collection_ip character varying(50),
    equipment_collection_status character varying(10),
    equipment_collection_type character varying(10),
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50)
);


ALTER TABLE public.iot_equipment_collection OWNER TO postgres;

--
-- Name: TABLE iot_equipment_collection; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_equipment_collection IS '设备采集方式表';


--
-- Name: COLUMN iot_equipment_collection.equipment_collection_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_collection.equipment_collection_id IS '设备采集方式ID';


--
-- Name: COLUMN iot_equipment_collection.equipment_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_collection.equipment_id IS '设备ID';


--
-- Name: COLUMN iot_equipment_collection.collection_mode_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_collection.collection_mode_id IS '采集方式ID';


--
-- Name: COLUMN iot_equipment_collection.collection_ip; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_collection.collection_ip IS '采集IP';


--
-- Name: COLUMN iot_equipment_collection.equipment_collection_status; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_collection.equipment_collection_status IS '设备采集方式状态';


--
-- Name: COLUMN iot_equipment_collection.equipment_collection_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_collection.equipment_collection_type IS '设备采集方式类型';


--
-- Name: COLUMN iot_equipment_collection.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_collection.remarks IS '备注';


--
-- Name: COLUMN iot_equipment_collection.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_collection.creation_time IS '创建时间';


--
-- Name: COLUMN iot_equipment_collection.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_collection.creation_user IS '创建人';


--
-- Name: iot_equipment_file; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_equipment_file (
    equipment_file_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    equipment_id uuid,
    equipment_file_name character varying(50),
    equipment_file_url character varying(100),
    equipment_file_type character varying(10),
    equipment_file_status character varying(10),
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_equipment_file OWNER TO postgres;

--
-- Name: TABLE iot_equipment_file; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_equipment_file IS '设备文件表';


--
-- Name: COLUMN iot_equipment_file.equipment_file_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_file.equipment_file_id IS '设备文件ID';


--
-- Name: COLUMN iot_equipment_file.equipment_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_file.equipment_id IS '设备ID';


--
-- Name: COLUMN iot_equipment_file.equipment_file_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_file.equipment_file_name IS '设备文件名称';


--
-- Name: COLUMN iot_equipment_file.equipment_file_url; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_file.equipment_file_url IS '设备文件地址';


--
-- Name: COLUMN iot_equipment_file.equipment_file_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_file.equipment_file_type IS '设备文件类型';


--
-- Name: COLUMN iot_equipment_file.equipment_file_status; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_file.equipment_file_status IS '设备文件状态';


--
-- Name: COLUMN iot_equipment_file.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_file.remarks IS '备注';


--
-- Name: COLUMN iot_equipment_file.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_file.creation_time IS '创建时间';


--
-- Name: COLUMN iot_equipment_file.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_file.creation_user IS '创建人';


--
-- Name: COLUMN iot_equipment_file.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_file.update_time IS '更新时间';


--
-- Name: COLUMN iot_equipment_file.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_file.update_user IS '更新人';


--
-- Name: COLUMN iot_equipment_file.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_file.spare1 IS '备用1';


--
-- Name: COLUMN iot_equipment_file.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_file.spare2 IS '备用2';


--
-- Name: COLUMN iot_equipment_file.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_file.spare3 IS '备用3';


--
-- Name: iot_equipment_type; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_equipment_type (
    equipment_type_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    equipment_type_name character varying(50),
    equipment_type_status character varying(10),
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_equipment_type OWNER TO postgres;

--
-- Name: TABLE iot_equipment_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_equipment_type IS '设备类型表';


--
-- Name: COLUMN iot_equipment_type.equipment_type_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_type.equipment_type_id IS '设备类型ID';


--
-- Name: COLUMN iot_equipment_type.equipment_type_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_type.equipment_type_name IS '设备类型名称';


--
-- Name: COLUMN iot_equipment_type.equipment_type_status; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_type.equipment_type_status IS '设备类型状态';


--
-- Name: COLUMN iot_equipment_type.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_type.remarks IS '备注';


--
-- Name: COLUMN iot_equipment_type.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_type.creation_time IS '创建时间';


--
-- Name: COLUMN iot_equipment_type.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_type.creation_user IS '创建人';


--
-- Name: COLUMN iot_equipment_type.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_type.update_time IS '更新时间';


--
-- Name: COLUMN iot_equipment_type.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_type.update_user IS '更新人';


--
-- Name: COLUMN iot_equipment_type.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_type.spare1 IS '备用1';


--
-- Name: COLUMN iot_equipment_type.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_type.spare2 IS '备用2';


--
-- Name: COLUMN iot_equipment_type.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_equipment_type.spare3 IS '备用3';


--
-- Name: iot_member; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_member (
    user_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    role_id uuid,
    user_code character varying(50),
    user_name character varying(50),
    user_account character varying(50),
    user_password character varying(50),
    user_state integer,
    user_type integer,
    last_login_time timestamp(0) without time zone,
    last_login_ip character varying(20),
    login_num integer,
    user_sex character varying(10),
    user_email character varying(50),
    user_phone_num character varying(50),
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_member OWNER TO postgres;

--
-- Name: TABLE iot_member; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_member IS '系统用户表';


--
-- Name: COLUMN iot_member.user_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.user_id IS '用户ID';


--
-- Name: COLUMN iot_member.role_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.role_id IS '角色ID';


--
-- Name: COLUMN iot_member.user_code; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.user_code IS '用户编码';


--
-- Name: COLUMN iot_member.user_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.user_name IS '用户名称';


--
-- Name: COLUMN iot_member.user_account; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.user_account IS '用户账户';


--
-- Name: COLUMN iot_member.user_password; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.user_password IS '用户密码 MD5加密';


--
-- Name: COLUMN iot_member.user_state; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.user_state IS '用户状态 1在用 0停用';


--
-- Name: COLUMN iot_member.user_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.user_type IS '用户类型 1超级管理员 2普通管理员 3普通用户';


--
-- Name: COLUMN iot_member.last_login_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.last_login_time IS '最后登录时间';


--
-- Name: COLUMN iot_member.last_login_ip; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.last_login_ip IS '最后登录IP';


--
-- Name: COLUMN iot_member.login_num; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.login_num IS '登陆次数';


--
-- Name: COLUMN iot_member.user_sex; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.user_sex IS '性别';


--
-- Name: COLUMN iot_member.user_email; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.user_email IS '邮箱';


--
-- Name: COLUMN iot_member.user_phone_num; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.user_phone_num IS '手机号';


--
-- Name: COLUMN iot_member.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.remarks IS '备注';


--
-- Name: COLUMN iot_member.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.creation_time IS '创建时间';


--
-- Name: COLUMN iot_member.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.creation_user IS '创建人';


--
-- Name: COLUMN iot_member.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.update_time IS '更新时间';


--
-- Name: COLUMN iot_member.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.update_user IS '更新人';


--
-- Name: COLUMN iot_member.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.spare1 IS '备用1';


--
-- Name: COLUMN iot_member.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.spare2 IS '备用2';


--
-- Name: COLUMN iot_member.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_member.spare3 IS '备用3';


--
-- Name: iot_menu; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_menu (
    menu_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    menu_name character varying(50),
    menu_url character varying(100),
    parent_menu_id character varying(50),
    menu_level integer,
    menu_serial_num integer,
    menu_icon character varying(100),
    menu_status character varying(10),
    menu_type character varying(10),
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_menu OWNER TO postgres;

--
-- Name: TABLE iot_menu; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_menu IS '菜单表';


--
-- Name: COLUMN iot_menu.menu_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.menu_id IS '菜单ID';


--
-- Name: COLUMN iot_menu.menu_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.menu_name IS '菜单名称';


--
-- Name: COLUMN iot_menu.menu_url; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.menu_url IS '菜单URL地址';


--
-- Name: COLUMN iot_menu.parent_menu_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.parent_menu_id IS '父菜单ID';


--
-- Name: COLUMN iot_menu.menu_level; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.menu_level IS '菜单所属层级';


--
-- Name: COLUMN iot_menu.menu_serial_num; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.menu_serial_num IS '顺序号';


--
-- Name: COLUMN iot_menu.menu_icon; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.menu_icon IS '图标';


--
-- Name: COLUMN iot_menu.menu_status; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.menu_status IS '菜单状态';


--
-- Name: COLUMN iot_menu.menu_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.menu_type IS '菜单类型';


--
-- Name: COLUMN iot_menu.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.remarks IS '备注';


--
-- Name: COLUMN iot_menu.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.creation_time IS '创建时间';


--
-- Name: COLUMN iot_menu.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.creation_user IS '创建人';


--
-- Name: COLUMN iot_menu.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.update_time IS '更新时间';


--
-- Name: COLUMN iot_menu.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.update_user IS '更新人';


--
-- Name: COLUMN iot_menu.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.spare1 IS '备用1';


--
-- Name: COLUMN iot_menu.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.spare2 IS '备用2';


--
-- Name: COLUMN iot_menu.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_menu.spare3 IS '备用3';


--
-- Name: iot_org; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_org (
    org_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    org_code character varying(50),
    org_name character varying(50),
    parentorg_id character varying(50),
    org_status character varying(10),
    org_type character varying(10),
    org_level integer,
    org_country character varying(50),
    org_province character varying(50),
    org_city character varying(50),
    org_long_itude character varying(50),
    org_dimension character varying(50),
    org_serial_num integer,
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_org OWNER TO postgres;

--
-- Name: TABLE iot_org; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_org IS '组织表';


--
-- Name: COLUMN iot_org.org_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.org_id IS '组织ID';


--
-- Name: COLUMN iot_org.org_code; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.org_code IS '组织编码';


--
-- Name: COLUMN iot_org.org_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.org_name IS '组织名称';


--
-- Name: COLUMN iot_org.parentorg_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.parentorg_id IS '父组织ID';


--
-- Name: COLUMN iot_org.org_status; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.org_status IS '组织状态1可用 0停用';


--
-- Name: COLUMN iot_org.org_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.org_type IS '组织类型';


--
-- Name: COLUMN iot_org.org_level; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.org_level IS '组织层级';


--
-- Name: COLUMN iot_org.org_country; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.org_country IS '国家';


--
-- Name: COLUMN iot_org.org_province; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.org_province IS '省份';


--
-- Name: COLUMN iot_org.org_city; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.org_city IS '市';


--
-- Name: COLUMN iot_org.org_long_itude; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.org_long_itude IS '经度';


--
-- Name: COLUMN iot_org.org_dimension; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.org_dimension IS '纬度';


--
-- Name: COLUMN iot_org.org_serial_num; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.org_serial_num IS '顺序号';


--
-- Name: COLUMN iot_org.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.remarks IS '备注';


--
-- Name: COLUMN iot_org.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.creation_time IS '创建时间';


--
-- Name: COLUMN iot_org.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.creation_user IS '创建人';


--
-- Name: COLUMN iot_org.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.update_time IS '更新时间';


--
-- Name: COLUMN iot_org.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.update_user IS '更新人';


--
-- Name: COLUMN iot_org.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.spare1 IS '备用1';


--
-- Name: COLUMN iot_org.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.spare2 IS '备用2';


--
-- Name: COLUMN iot_org.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_org.spare3 IS '备用3';


--
-- Name: iot_point_warning; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_point_warning (
    point_warning_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    collection_point_id uuid,
    point_warning_name character varying(50),
    point_warning_rule character varying(1000),
    point_warning_evel character varying(50),
    point_warning_event character varying(1000),
    point_warning_rate integer,
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_point_warning OWNER TO postgres;

--
-- Name: TABLE iot_point_warning; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_point_warning IS '采集点预警表';


--
-- Name: COLUMN iot_point_warning.point_warning_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.point_warning_id IS '采集点预警ID';


--
-- Name: COLUMN iot_point_warning.collection_point_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.collection_point_id IS '采集点ID';


--
-- Name: COLUMN iot_point_warning.point_warning_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.point_warning_name IS '预警名称';


--
-- Name: COLUMN iot_point_warning.point_warning_rule; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.point_warning_rule IS '预警规则';


--
-- Name: COLUMN iot_point_warning.point_warning_evel; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.point_warning_evel IS '预警级别';


--
-- Name: COLUMN iot_point_warning.point_warning_event; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.point_warning_event IS '预警事件';


--
-- Name: COLUMN iot_point_warning.point_warning_rate; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.point_warning_rate IS '预警间隔时间，单位秒';


--
-- Name: COLUMN iot_point_warning.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.remarks IS '备注';


--
-- Name: COLUMN iot_point_warning.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.creation_time IS '创建时间';


--
-- Name: COLUMN iot_point_warning.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.creation_user IS '创建人';


--
-- Name: COLUMN iot_point_warning.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.update_time IS '更新时间';


--
-- Name: COLUMN iot_point_warning.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.update_user IS '更新人';


--
-- Name: COLUMN iot_point_warning.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.spare1 IS '备用1';


--
-- Name: COLUMN iot_point_warning.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.spare2 IS '备用2';


--
-- Name: COLUMN iot_point_warning.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_point_warning.spare3 IS '备用3';


--
-- Name: iot_product_line; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_product_line (
    product_line_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    work_shop_id uuid,
    product_line_code character varying(50),
    product_line_name character varying(50),
    product_line_status character varying(10),
    product_line_type character varying(10),
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_product_line OWNER TO postgres;

--
-- Name: TABLE iot_product_line; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_product_line IS '产线表';


--
-- Name: COLUMN iot_product_line.product_line_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_product_line.product_line_id IS '产线ID';


--
-- Name: COLUMN iot_product_line.work_shop_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_product_line.work_shop_id IS '车间ID';


--
-- Name: COLUMN iot_product_line.product_line_code; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_product_line.product_line_code IS '产线代码';


--
-- Name: COLUMN iot_product_line.product_line_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_product_line.product_line_name IS '产线名称';


--
-- Name: COLUMN iot_product_line.product_line_status; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_product_line.product_line_status IS '产线状态';


--
-- Name: COLUMN iot_product_line.product_line_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_product_line.product_line_type IS '产线类型';


--
-- Name: COLUMN iot_product_line.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_product_line.remarks IS '备注';


--
-- Name: COLUMN iot_product_line.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_product_line.creation_time IS '创建时间';


--
-- Name: COLUMN iot_product_line.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_product_line.creation_user IS '创建人';


--
-- Name: COLUMN iot_product_line.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_product_line.update_time IS '更新时间';


--
-- Name: COLUMN iot_product_line.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_product_line.update_user IS '更新人';


--
-- Name: COLUMN iot_product_line.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_product_line.spare1 IS '备用1';


--
-- Name: COLUMN iot_product_line.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_product_line.spare2 IS '备用2';


--
-- Name: COLUMN iot_product_line.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_product_line.spare3 IS '备用3';


--
-- Name: iot_role; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_role (
    role_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    role_name character varying(50),
    role_status integer,
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_role OWNER TO postgres;

--
-- Name: TABLE iot_role; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_role IS '角色表';


--
-- Name: COLUMN iot_role.role_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role.role_id IS '角色ID';


--
-- Name: COLUMN iot_role.role_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role.role_name IS '角色名称';


--
-- Name: COLUMN iot_role.role_status; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role.role_status IS '角色状态';


--
-- Name: COLUMN iot_role.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role.remarks IS '备注';


--
-- Name: COLUMN iot_role.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role.creation_time IS '创建时间';


--
-- Name: COLUMN iot_role.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role.creation_user IS '创建人';


--
-- Name: COLUMN iot_role.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role.update_time IS '更新时间';


--
-- Name: COLUMN iot_role.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role.update_user IS '更新人';


--
-- Name: COLUMN iot_role.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role.spare1 IS '备用1';


--
-- Name: COLUMN iot_role.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role.spare2 IS '备用2';


--
-- Name: COLUMN iot_role.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role.spare3 IS '备用3';


--
-- Name: iot_role_auth; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_role_auth (
    role_auth_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    role_id uuid,
    menu_id uuid,
    button_id character varying(50),
    creation_time timestamp(0) without time zone,
    creation_user character varying(50)
);


ALTER TABLE public.iot_role_auth OWNER TO postgres;

--
-- Name: TABLE iot_role_auth; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_role_auth IS '角色权限表';


--
-- Name: COLUMN iot_role_auth.role_auth_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role_auth.role_auth_id IS '角色权限ID';


--
-- Name: COLUMN iot_role_auth.role_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role_auth.role_id IS '角色ID';


--
-- Name: COLUMN iot_role_auth.menu_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role_auth.menu_id IS '菜单ID';


--
-- Name: COLUMN iot_role_auth.button_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role_auth.button_id IS '按钮ID';


--
-- Name: COLUMN iot_role_auth.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role_auth.creation_time IS '创建时间';


--
-- Name: COLUMN iot_role_auth.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_role_auth.creation_user IS '创建人';


--
-- Name: iot_user_org; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_user_org (
    user_org_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    user_id uuid,
    org_id uuid,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50)
);


ALTER TABLE public.iot_user_org OWNER TO postgres;

--
-- Name: TABLE iot_user_org; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_user_org IS '用户组织表';


--
-- Name: COLUMN iot_user_org.user_org_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_user_org.user_org_id IS '用户组织ID';


--
-- Name: COLUMN iot_user_org.user_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_user_org.user_id IS '用户ID';


--
-- Name: COLUMN iot_user_org.org_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_user_org.org_id IS '组织ID';


--
-- Name: COLUMN iot_user_org.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_user_org.creation_time IS '创建时间';


--
-- Name: COLUMN iot_user_org.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_user_org.creation_user IS '创建人';


--
-- Name: iot_warning_feedback; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_warning_feedback (
    warning_feedback_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    warning_record_id uuid,
    warning_feedback_subject character varying(200),
    warning_feedback_content text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_warning_feedback OWNER TO postgres;

--
-- Name: TABLE iot_warning_feedback; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_warning_feedback IS '预警记录反馈表';


--
-- Name: COLUMN iot_warning_feedback.warning_feedback_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_feedback.warning_feedback_id IS '预警反馈ID';


--
-- Name: COLUMN iot_warning_feedback.warning_record_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_feedback.warning_record_id IS '预警记录ID';


--
-- Name: COLUMN iot_warning_feedback.warning_feedback_subject; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_feedback.warning_feedback_subject IS '预警反馈主题';


--
-- Name: COLUMN iot_warning_feedback.warning_feedback_content; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_feedback.warning_feedback_content IS '预警反馈内容';


--
-- Name: COLUMN iot_warning_feedback.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_feedback.creation_time IS '创建时间';


--
-- Name: COLUMN iot_warning_feedback.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_feedback.creation_user IS '创建人';


--
-- Name: COLUMN iot_warning_feedback.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_feedback.update_time IS '更新时间';


--
-- Name: COLUMN iot_warning_feedback.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_feedback.update_user IS '更新人';


--
-- Name: COLUMN iot_warning_feedback.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_feedback.spare1 IS '备用1';


--
-- Name: COLUMN iot_warning_feedback.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_feedback.spare2 IS '备用2';


--
-- Name: COLUMN iot_warning_feedback.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_feedback.spare3 IS '备用3';


--
-- Name: iot_warning_notify; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_warning_notify (
    warning_notify_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    collection_point_id uuid,
    warning_notify_name character varying(50),
    warning_notify_type character varying(10),
    warning_notify_parameter1 character varying(100),
    warning_notify_parameter2 character varying(100),
    warning_notify_parameter3 character varying(100),
    warning_notify_content text,
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_warning_notify OWNER TO postgres;

--
-- Name: TABLE iot_warning_notify; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_warning_notify IS '报警消息推送表';


--
-- Name: COLUMN iot_warning_notify.warning_notify_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.warning_notify_id IS '报警推送ID';


--
-- Name: COLUMN iot_warning_notify.collection_point_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.collection_point_id IS '采集点预警ID';


--
-- Name: COLUMN iot_warning_notify.warning_notify_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.warning_notify_name IS '报警推送名称';


--
-- Name: COLUMN iot_warning_notify.warning_notify_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.warning_notify_type IS '报警推送类型';


--
-- Name: COLUMN iot_warning_notify.warning_notify_parameter1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.warning_notify_parameter1 IS '报警推送参数1';


--
-- Name: COLUMN iot_warning_notify.warning_notify_parameter2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.warning_notify_parameter2 IS '报警推送参数2';


--
-- Name: COLUMN iot_warning_notify.warning_notify_parameter3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.warning_notify_parameter3 IS '报警推送参数3';


--
-- Name: COLUMN iot_warning_notify.warning_notify_content; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.warning_notify_content IS '预警内容';


--
-- Name: COLUMN iot_warning_notify.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.remarks IS '备注';


--
-- Name: COLUMN iot_warning_notify.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.creation_time IS '创建时间';


--
-- Name: COLUMN iot_warning_notify.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.creation_user IS '创建人';


--
-- Name: COLUMN iot_warning_notify.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.update_time IS '更新时间';


--
-- Name: COLUMN iot_warning_notify.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.update_user IS '更新人';


--
-- Name: COLUMN iot_warning_notify.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.spare1 IS '备用1';


--
-- Name: COLUMN iot_warning_notify.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.spare2 IS '备用2';


--
-- Name: COLUMN iot_warning_notify.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_notify.spare3 IS '备用3';


--
-- Name: iot_warning_record; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_warning_record (
    warning_record_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    equipment_id character varying(50),
    equipment_name character varying(50),
    collection_mode_id character varying(50),
    collection_mode_name character varying(50),
    collection_point_id character varying(50),
    collection_point_name character varying(50),
    collection_point_type character varying(10),
    collection_point_value character varying(50),
    collection_point_result character varying(50),
    point_warning_id character varying(50),
    point_warning_name character varying(50),
    point_warning_rule character varying(1000),
    point_warning_evel character varying(50),
    point_warning_event character varying(1000),
    warning_notify_id character varying(50),
    warning_notify_name character varying(50),
    warning_notify_type character varying(50),
    warning_notify_parameter1 character varying(100),
    warning_notify_parameter2 character varying(100),
    warning_notify_parameter3 character varying(100),
    warning_notify_content character varying(50),
    warning_record_status character varying(50),
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_warning_record OWNER TO postgres;

--
-- Name: TABLE iot_warning_record; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_warning_record IS '预警记录表';


--
-- Name: COLUMN iot_warning_record.warning_record_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.warning_record_id IS '预警记录ID';


--
-- Name: COLUMN iot_warning_record.equipment_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.equipment_id IS '设备ID';


--
-- Name: COLUMN iot_warning_record.equipment_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.equipment_name IS '设备名称';


--
-- Name: COLUMN iot_warning_record.collection_mode_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.collection_mode_id IS '采集方式ID';


--
-- Name: COLUMN iot_warning_record.collection_mode_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.collection_mode_name IS '采集方式名称';


--
-- Name: COLUMN iot_warning_record.collection_point_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.collection_point_id IS '采集点ID';


--
-- Name: COLUMN iot_warning_record.collection_point_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.collection_point_name IS '采集点名称';


--
-- Name: COLUMN iot_warning_record.collection_point_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.collection_point_type IS '采集点类型';


--
-- Name: COLUMN iot_warning_record.collection_point_value; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.collection_point_value IS '采集原始值';


--
-- Name: COLUMN iot_warning_record.collection_point_result; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.collection_point_result IS '采集处理值';


--
-- Name: COLUMN iot_warning_record.point_warning_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.point_warning_id IS '采集点预警ID';


--
-- Name: COLUMN iot_warning_record.point_warning_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.point_warning_name IS '预警名称';


--
-- Name: COLUMN iot_warning_record.point_warning_rule; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.point_warning_rule IS '预警规则';


--
-- Name: COLUMN iot_warning_record.point_warning_evel; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.point_warning_evel IS '预警级别';


--
-- Name: COLUMN iot_warning_record.point_warning_event; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.point_warning_event IS '预警事件';


--
-- Name: COLUMN iot_warning_record.warning_notify_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.warning_notify_id IS '报警推送ID';


--
-- Name: COLUMN iot_warning_record.warning_notify_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.warning_notify_name IS '报警推送名称';


--
-- Name: COLUMN iot_warning_record.warning_notify_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.warning_notify_type IS '报警推送类型';


--
-- Name: COLUMN iot_warning_record.warning_notify_parameter1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.warning_notify_parameter1 IS '推送参数1';


--
-- Name: COLUMN iot_warning_record.warning_notify_parameter2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.warning_notify_parameter2 IS '推送参数2';


--
-- Name: COLUMN iot_warning_record.warning_notify_parameter3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.warning_notify_parameter3 IS '推送参数3';


--
-- Name: COLUMN iot_warning_record.warning_notify_content; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.warning_notify_content IS '预警内容';


--
-- Name: COLUMN iot_warning_record.warning_record_status; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.warning_record_status IS '预警记录状态';


--
-- Name: COLUMN iot_warning_record.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.remarks IS '备注';


--
-- Name: COLUMN iot_warning_record.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.creation_time IS '创建时间';


--
-- Name: COLUMN iot_warning_record.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.creation_user IS '创建人';


--
-- Name: COLUMN iot_warning_record.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.update_time IS '更新时间';


--
-- Name: COLUMN iot_warning_record.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.update_user IS '更新人';


--
-- Name: COLUMN iot_warning_record.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.spare1 IS '备用1';


--
-- Name: COLUMN iot_warning_record.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.spare2 IS '备用2';


--
-- Name: COLUMN iot_warning_record.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_warning_record.spare3 IS '备用3';


--
-- Name: iot_work_shop; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.iot_work_shop (
    work_shop_id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    work_shop_code character varying(50),
    work_shop_name character varying(50),
    org_id character varying(50),
    work_shop_type character varying(10),
    work_shop_status character varying(10),
    work_shop_country character varying(50),
    work_shop_province character varying(50),
    work_shop_city character varying(50),
    work_shop_longitude character varying(50),
    work_shop_dimension character varying(50),
    remarks text,
    creation_time timestamp(0) without time zone,
    creation_user character varying(50),
    update_time timestamp(0) without time zone,
    update_user character varying(50),
    spare1 character varying(100),
    spare2 character varying(100),
    spare3 character varying(100)
);


ALTER TABLE public.iot_work_shop OWNER TO postgres;

--
-- Name: TABLE iot_work_shop; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.iot_work_shop IS '车间表';


--
-- Name: COLUMN iot_work_shop.work_shop_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.work_shop_id IS '车间ID';


--
-- Name: COLUMN iot_work_shop.work_shop_code; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.work_shop_code IS '车间代码';


--
-- Name: COLUMN iot_work_shop.work_shop_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.work_shop_name IS '车间名称';


--
-- Name: COLUMN iot_work_shop.org_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.org_id IS '所属组织ID';


--
-- Name: COLUMN iot_work_shop.work_shop_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.work_shop_type IS '车间类型';


--
-- Name: COLUMN iot_work_shop.work_shop_status; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.work_shop_status IS '车间状态';


--
-- Name: COLUMN iot_work_shop.work_shop_country; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.work_shop_country IS '国家';


--
-- Name: COLUMN iot_work_shop.work_shop_province; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.work_shop_province IS '省份';


--
-- Name: COLUMN iot_work_shop.work_shop_city; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.work_shop_city IS '市';


--
-- Name: COLUMN iot_work_shop.work_shop_longitude; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.work_shop_longitude IS '经度';


--
-- Name: COLUMN iot_work_shop.work_shop_dimension; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.work_shop_dimension IS '纬度';


--
-- Name: COLUMN iot_work_shop.remarks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.remarks IS '备注';


--
-- Name: COLUMN iot_work_shop.creation_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.creation_time IS '创建时间';


--
-- Name: COLUMN iot_work_shop.creation_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.creation_user IS '创建人';


--
-- Name: COLUMN iot_work_shop.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.update_time IS '更新时间';


--
-- Name: COLUMN iot_work_shop.update_user; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.update_user IS '更新人';


--
-- Name: COLUMN iot_work_shop.spare1; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.spare1 IS '备用1';


--
-- Name: COLUMN iot_work_shop.spare2; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.spare2 IS '备用2';


--
-- Name: COLUMN iot_work_shop.spare3; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.iot_work_shop.spare3 IS '备用3';


--
-- Name: sys_admin_user; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_admin_user (
    id bigint NOT NULL,
    username character varying(20) DEFAULT ''::character varying,
    password character varying(50),
    real_name character varying(25) DEFAULT ''::character varying,
    email character varying(30) DEFAULT ''::character varying,
    telephone character varying(20) DEFAULT ''::character varying,
    mobile_phone character varying(20) DEFAULT ''::character varying,
    address character varying(100) DEFAULT ''::character varying,
    create_time timestamp without time zone,
    update_time timestamp without time zone,
    role_id bigint,
    enabled boolean,
    credentials_non_expired boolean,
    account_non_expired boolean,
    account_non_locked boolean
);


ALTER TABLE public.sys_admin_user OWNER TO postgres;

--
-- Name: COLUMN sys_admin_user.id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_admin_user.id IS '主键';


--
-- Name: COLUMN sys_admin_user.username; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_admin_user.username IS '用户名';


--
-- Name: COLUMN sys_admin_user.password; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_admin_user.password IS '密码';


--
-- Name: COLUMN sys_admin_user.email; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_admin_user.email IS '邮箱';


--
-- Name: COLUMN sys_admin_user.telephone; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_admin_user.telephone IS '座机';


--
-- Name: COLUMN sys_admin_user.mobile_phone; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_admin_user.mobile_phone IS '手机号';


--
-- Name: COLUMN sys_admin_user.address; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_admin_user.address IS '地址';


--
-- Name: COLUMN sys_admin_user.create_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_admin_user.create_time IS '创建时间';


--
-- Name: COLUMN sys_admin_user.update_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_admin_user.update_time IS '更新时间';


--
-- Name: COLUMN sys_admin_user.role_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_admin_user.role_id IS '角色';


--
-- Name: COLUMN sys_admin_user.enabled; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_admin_user.enabled IS '是否启用';


--
-- Name: COLUMN sys_admin_user.credentials_non_expired; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_admin_user.credentials_non_expired IS '是否过期';


--
-- Name: COLUMN sys_admin_user.account_non_expired; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_admin_user.account_non_expired IS '是否未过期 暂未使用';


--
-- Name: COLUMN sys_admin_user.account_non_locked; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_admin_user.account_non_locked IS '是否锁定 暂未使用';


--
-- Name: sys_admin_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_admin_user_id_seq
    START WITH 2000
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_admin_user_id_seq OWNER TO postgres;

--
-- Name: sys_admin_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_admin_user_id_seq OWNED BY public.sys_admin_user.id;


--
-- Name: sys_global_permit_url; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_global_permit_url (
    id bigint NOT NULL,
    permit_name character varying(50) DEFAULT ''::character varying,
    backend_url_reg character varying(200) DEFAULT ''::character varying,
    module_id bigint
);


ALTER TABLE public.sys_global_permit_url OWNER TO postgres;

--
-- Name: TABLE sys_global_permit_url; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.sys_global_permit_url IS '后端请求地址全局允许过滤器,在此表的统一不用再去权限表匹配了';


--
-- Name: COLUMN sys_global_permit_url.id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_global_permit_url.id IS '主键';


--
-- Name: COLUMN sys_global_permit_url.permit_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_global_permit_url.permit_name IS '通过名称';


--
-- Name: COLUMN sys_global_permit_url.backend_url_reg; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_global_permit_url.backend_url_reg IS '后端的地址正则,校验当前请求url是否有权限,get|post统一会按照参数首字母排序';


--
-- Name: COLUMN sys_global_permit_url.module_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_global_permit_url.module_id IS '所属模块';


--
-- Name: sys_global_permit_url_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_global_permit_url_id_seq
    START WITH 2000
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_global_permit_url_id_seq OWNER TO postgres;

--
-- Name: sys_global_permit_url_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_global_permit_url_id_seq OWNED BY public.sys_global_permit_url.id;


--
-- Name: sys_log_admin_operate_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_log_admin_operate_id_seq
    START WITH 2000
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_log_admin_operate_id_seq OWNER TO postgres;

--
-- Name: sys_log_admin_operate; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_log_admin_operate (
    id bigint DEFAULT nextval('public.sys_log_admin_operate_id_seq'::regclass) NOT NULL,
    admin_user_id bigint,
    user_name character varying(100) DEFAULT ''::character varying,
    table_name character varying(100) DEFAULT ''::character varying,
    operate_type character varying(50) DEFAULT ''::character varying,
    url character varying(200) DEFAULT ''::character varying,
    primary_id_value character varying(100) DEFAULT ''::character varying,
    form_body text,
    create_time timestamp without time zone
);


ALTER TABLE public.sys_log_admin_operate OWNER TO postgres;

--
-- Name: TABLE sys_log_admin_operate; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.sys_log_admin_operate IS '系统操作日志';


--
-- Name: COLUMN sys_log_admin_operate.id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_log_admin_operate.id IS '主键';


--
-- Name: COLUMN sys_log_admin_operate.admin_user_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_log_admin_operate.admin_user_id IS '管理员';


--
-- Name: COLUMN sys_log_admin_operate.user_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_log_admin_operate.user_name IS '管理员名称';


--
-- Name: COLUMN sys_log_admin_operate.table_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_log_admin_operate.table_name IS '表名';


--
-- Name: COLUMN sys_log_admin_operate.operate_type; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_log_admin_operate.operate_type IS '操作类型';


--
-- Name: COLUMN sys_log_admin_operate.url; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_log_admin_operate.url IS '链接';


--
-- Name: COLUMN sys_log_admin_operate.primary_id_value; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_log_admin_operate.primary_id_value IS '主键值';


--
-- Name: COLUMN sys_log_admin_operate.form_body; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_log_admin_operate.form_body IS '提交内容';


--
-- Name: COLUMN sys_log_admin_operate.create_time; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_log_admin_operate.create_time IS '创建时间';


--
-- Name: sys_module; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_module (
    id bigint NOT NULL,
    module_name character varying(200) DEFAULT ''::character varying,
    module_url character varying(200) DEFAULT ''::character varying,
    module_category_id bigint DEFAULT '0'::bigint,
    sort_num integer DEFAULT 0,
    module_title character varying(50) DEFAULT ''::character varying,
    if_show boolean
);


ALTER TABLE public.sys_module OWNER TO postgres;

--
-- Name: COLUMN sys_module.id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_module.id IS '主键';


--
-- Name: COLUMN sys_module.module_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_module.module_name IS '模块名称';


--
-- Name: COLUMN sys_module.module_url; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_module.module_url IS '模块URL';


--
-- Name: COLUMN sys_module.module_category_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_module.module_category_id IS '模块类目';


--
-- Name: COLUMN sys_module.sort_num; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_module.sort_num IS '排序';


--
-- Name: COLUMN sys_module.module_title; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_module.module_title IS '模块标题';


--
-- Name: sys_module_category; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_module_category (
    id bigint NOT NULL,
    module_category_name character varying(20) DEFAULT ''::character varying,
    sort_num integer DEFAULT 0
);


ALTER TABLE public.sys_module_category OWNER TO postgres;

--
-- Name: TABLE sys_module_category; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.sys_module_category IS '模块分类';


--
-- Name: COLUMN sys_module_category.id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_module_category.id IS '主键';


--
-- Name: COLUMN sys_module_category.module_category_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_module_category.module_category_name IS '模块名称';


--
-- Name: COLUMN sys_module_category.sort_num; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_module_category.sort_num IS '排序';


--
-- Name: sys_module_category_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_module_category_id_seq
    START WITH 2000
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_module_category_id_seq OWNER TO postgres;

--
-- Name: sys_module_category_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_module_category_id_seq OWNED BY public.sys_module_category.id;


--
-- Name: sys_module_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_module_id_seq
    START WITH 2000
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_module_id_seq OWNER TO postgres;

--
-- Name: sys_module_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_module_id_seq OWNED BY public.sys_module.id;


--
-- Name: sys_permission; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_permission (
    id bigint NOT NULL,
    filter_platform character varying(50) DEFAULT ''::character varying,
    permission_name character varying(50) DEFAULT ''::character varying,
    backend_url_reg character varying(200) DEFAULT ''::character varying,
    front_dom character varying(1024) DEFAULT ''::character varying,
    front_action character varying(50) DEFAULT ''::character varying,
    module_id bigint
);


ALTER TABLE public.sys_permission OWNER TO postgres;

--
-- Name: TABLE sys_permission; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.sys_permission IS '权限';


--
-- Name: COLUMN sys_permission.id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_permission.id IS '主键';


--
-- Name: COLUMN sys_permission.filter_platform; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_permission.filter_platform IS '过滤端:front|backend|front_backend';


--
-- Name: COLUMN sys_permission.permission_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_permission.permission_name IS '过滤器名称:审核通过';


--
-- Name: COLUMN sys_permission.backend_url_reg; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_permission.backend_url_reg IS '后端的地址正则,校验当前请求url是否有权限,get|post统一会按照参数首字母排序';


--
-- Name: COLUMN sys_permission.front_dom; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_permission.front_dom IS '前端dom获取';


--
-- Name: COLUMN sys_permission.front_action; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_permission.front_action IS '前端处理方式show|disabled';


--
-- Name: COLUMN sys_permission.module_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_permission.module_id IS '所属模块';


--
-- Name: sys_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_permission_id_seq
    START WITH 2000
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_permission_id_seq OWNER TO postgres;

--
-- Name: sys_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_permission_id_seq OWNED BY public.sys_permission.id;


--
-- Name: sys_role; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_role (
    id bigint NOT NULL,
    role_name character varying(20) DEFAULT ''::character varying
);


ALTER TABLE public.sys_role OWNER TO postgres;

--
-- Name: COLUMN sys_role.id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_role.id IS '主键';


--
-- Name: COLUMN sys_role.role_name; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_role.role_name IS '角色名';


--
-- Name: sys_role_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_role_id_seq
    START WITH 2000
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_role_id_seq OWNER TO postgres;

--
-- Name: sys_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_role_id_seq OWNED BY public.sys_role.id;


--
-- Name: sys_role_module_permission; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sys_role_module_permission (
    id bigint NOT NULL,
    role_id bigint,
    module_id bigint,
    permission_id bigint
);


ALTER TABLE public.sys_role_module_permission OWNER TO postgres;

--
-- Name: TABLE sys_role_module_permission; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.sys_role_module_permission IS '角色模块权限';


--
-- Name: COLUMN sys_role_module_permission.id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_role_module_permission.id IS '主键';


--
-- Name: COLUMN sys_role_module_permission.role_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_role_module_permission.role_id IS '角色';


--
-- Name: COLUMN sys_role_module_permission.module_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_role_module_permission.module_id IS '模块';


--
-- Name: COLUMN sys_role_module_permission.permission_id; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.sys_role_module_permission.permission_id IS '权限';


--
-- Name: sys_role_module_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sys_role_module_permission_id_seq
    START WITH 2000
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sys_role_module_permission_id_seq OWNER TO postgres;

--
-- Name: sys_role_module_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sys_role_module_permission_id_seq OWNED BY public.sys_role_module_permission.id;


--
-- Name: dict id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.dict ALTER COLUMN id SET DEFAULT nextval('public.dict_id_seq'::regclass);


--
-- Name: sys_admin_user id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_admin_user ALTER COLUMN id SET DEFAULT nextval('public.sys_admin_user_id_seq'::regclass);


--
-- Name: sys_global_permit_url id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_global_permit_url ALTER COLUMN id SET DEFAULT nextval('public.sys_global_permit_url_id_seq'::regclass);


--
-- Name: sys_module id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_module ALTER COLUMN id SET DEFAULT nextval('public.sys_module_id_seq'::regclass);


--
-- Name: sys_module_category id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_module_category ALTER COLUMN id SET DEFAULT nextval('public.sys_module_category_id_seq'::regclass);


--
-- Name: sys_permission id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_permission ALTER COLUMN id SET DEFAULT nextval('public.sys_permission_id_seq'::regclass);


--
-- Name: sys_role id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_role ALTER COLUMN id SET DEFAULT nextval('public.sys_role_id_seq'::regclass);


--
-- Name: sys_role_module_permission id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_role_module_permission ALTER COLUMN id SET DEFAULT nextval('public.sys_role_module_permission_id_seq'::regclass);


--
-- Data for Name: cache_inval_extension; Type: TABLE DATA; Schema: _timescaledb_cache; Owner: postgres
--

COPY _timescaledb_cache.cache_inval_extension  FROM stdin;
\.


--
-- Data for Name: cache_inval_hypertable; Type: TABLE DATA; Schema: _timescaledb_cache; Owner: postgres
--

COPY _timescaledb_cache.cache_inval_hypertable  FROM stdin;
\.


--
-- Data for Name: hypertable; Type: TABLE DATA; Schema: _timescaledb_catalog; Owner: postgres
--

COPY _timescaledb_catalog.hypertable (id, schema_name, table_name, associated_schema_name, associated_table_prefix, num_dimensions, chunk_sizing_func_schema, chunk_sizing_func_name, chunk_target_size) FROM stdin;
\.


--
-- Data for Name: chunk; Type: TABLE DATA; Schema: _timescaledb_catalog; Owner: postgres
--

COPY _timescaledb_catalog.chunk (id, hypertable_id, schema_name, table_name) FROM stdin;
\.


--
-- Data for Name: dimension; Type: TABLE DATA; Schema: _timescaledb_catalog; Owner: postgres
--

COPY _timescaledb_catalog.dimension (id, hypertable_id, column_name, column_type, aligned, num_slices, partitioning_func_schema, partitioning_func, interval_length) FROM stdin;
\.


--
-- Data for Name: dimension_slice; Type: TABLE DATA; Schema: _timescaledb_catalog; Owner: postgres
--

COPY _timescaledb_catalog.dimension_slice (id, dimension_id, range_start, range_end) FROM stdin;
\.


--
-- Data for Name: chunk_constraint; Type: TABLE DATA; Schema: _timescaledb_catalog; Owner: postgres
--

COPY _timescaledb_catalog.chunk_constraint (chunk_id, dimension_slice_id, constraint_name, hypertable_constraint_name) FROM stdin;
\.


--
-- Data for Name: chunk_index; Type: TABLE DATA; Schema: _timescaledb_catalog; Owner: postgres
--

COPY _timescaledb_catalog.chunk_index (chunk_id, index_name, hypertable_id, hypertable_index_name) FROM stdin;
\.


--
-- Data for Name: installation_metadata; Type: TABLE DATA; Schema: _timescaledb_catalog; Owner: postgres
--

COPY _timescaledb_catalog.installation_metadata (key, value) FROM stdin;
exported_uuid	d1bb19d5-b610-47dc-8716-8df2b2bc32a0
\.


--
-- Data for Name: tablespace; Type: TABLE DATA; Schema: _timescaledb_catalog; Owner: postgres
--

COPY _timescaledb_catalog.tablespace (id, hypertable_id, tablespace_name) FROM stdin;
\.


--
-- Data for Name: bgw_job; Type: TABLE DATA; Schema: _timescaledb_config; Owner: postgres
--

COPY _timescaledb_config.bgw_job (id, application_name, job_type, schedule_interval, max_runtime, max_retries, retry_period) FROM stdin;
\.


--
-- Data for Name: dict; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.dict (id, dict_category, code, name, dict_description, parent_id, create_time, update_time, order_no) FROM stdin;
\.


--
-- Data for Name: iot_button; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_button (button_id, menu_id, button_name, button_control_id, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_collection_mode; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_collection_mode (collection_mode_id, collection_mode_name, collection_mode_version, collection_mode_serial_num, collection_mode_status, collection_mode_type, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_collection_point; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_collection_point (collection_point_id, equipment_collection_id, collection_point_name, collection_point_type, collection_point_rate, collection_point_ip, collection_point_data_type, collection_point_data_process, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_dictionary_item; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_dictionary_item (item_id, type_id, itme_code, itme_name, itme_serial_num, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_dictionary_type; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_dictionary_type (type_id, type_code, type_name, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_equipment; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_equipment (equipment_id, product_line_id, equipment_type_id, equipment_code, equipment_name, equipment_status, equipment_ip, equipment_start_time, equipment_end_time, gateway_id, equipment_image, equipment_manager, equipment_brand, equipment_supplier, equipment_price, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_equipment_collection; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_equipment_collection (equipment_collection_id, equipment_id, collection_mode_id, collection_ip, equipment_collection_status, equipment_collection_type, remarks, creation_time, creation_user) FROM stdin;
\.


--
-- Data for Name: iot_equipment_file; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_equipment_file (equipment_file_id, equipment_id, equipment_file_name, equipment_file_url, equipment_file_type, equipment_file_status, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_equipment_type; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_equipment_type (equipment_type_id, equipment_type_name, equipment_type_status, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_member; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_member (user_id, role_id, user_code, user_name, user_account, user_password, user_state, user_type, last_login_time, last_login_ip, login_num, user_sex, user_email, user_phone_num, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_menu; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_menu (menu_id, menu_name, menu_url, parent_menu_id, menu_level, menu_serial_num, menu_icon, menu_status, menu_type, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_org; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_org (org_id, org_code, org_name, parentorg_id, org_status, org_type, org_level, org_country, org_province, org_city, org_long_itude, org_dimension, org_serial_num, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
49574b1a-ebb6-458a-a099-7c52f0c43826	a	a	a		a	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
\.


--
-- Data for Name: iot_point_warning; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_point_warning (point_warning_id, collection_point_id, point_warning_name, point_warning_rule, point_warning_evel, point_warning_event, point_warning_rate, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_product_line; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_product_line (product_line_id, work_shop_id, product_line_code, product_line_name, product_line_status, product_line_type, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_role; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_role (role_id, role_name, role_status, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_role_auth; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_role_auth (role_auth_id, role_id, menu_id, button_id, creation_time, creation_user) FROM stdin;
\.


--
-- Data for Name: iot_user_org; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_user_org (user_org_id, user_id, org_id, creation_time, creation_user) FROM stdin;
\.


--
-- Data for Name: iot_warning_feedback; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_warning_feedback (warning_feedback_id, warning_record_id, warning_feedback_subject, warning_feedback_content, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_warning_notify; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_warning_notify (warning_notify_id, collection_point_id, warning_notify_name, warning_notify_type, warning_notify_parameter1, warning_notify_parameter2, warning_notify_parameter3, warning_notify_content, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_warning_record; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_warning_record (warning_record_id, equipment_id, equipment_name, collection_mode_id, collection_mode_name, collection_point_id, collection_point_name, collection_point_type, collection_point_value, collection_point_result, point_warning_id, point_warning_name, point_warning_rule, point_warning_evel, point_warning_event, warning_notify_id, warning_notify_name, warning_notify_type, warning_notify_parameter1, warning_notify_parameter2, warning_notify_parameter3, warning_notify_content, warning_record_status, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
\.


--
-- Data for Name: iot_work_shop; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.iot_work_shop (work_shop_id, work_shop_code, work_shop_name, org_id, work_shop_type, work_shop_status, work_shop_country, work_shop_province, work_shop_city, work_shop_longitude, work_shop_dimension, remarks, creation_time, creation_user, update_time, update_user, spare1, spare2, spare3) FROM stdin;
cce4a0ca-0a8b-4af0-9d1f-94971ec1f3ed	a	b	49574b1a-ebb6-458a-a099-7c52f0c43826	n	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
\.


--
-- Data for Name: sys_admin_user; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_admin_user (id, username, password, real_name, email, telephone, mobile_phone, address, create_time, update_time, role_id, enabled, credentials_non_expired, account_non_expired, account_non_locked) FROM stdin;
7	magicalcoder	6860c37b00ed4e444a7d2c6e8fb66886	系统默认超级管理员账号					2018-09-06 00:00:00	2018-09-06 00:00:00	1	t	\N	\N	\N
4	test	098f6bcd4621d373cade4e832627b4f6	测试人员					2018-09-03 00:00:00	2018-09-03 00:00:00	2	t	\N	\N	\N
3	admin	21232f297a57a5a743894a0e4a801fc3	管理员					2018-07-30 00:00:00	2018-07-30 00:00:00	1	t	\N	\N	\N
2000	dp	202cb962ac59075b964b07152d234b70	dp	ddddd				2018-11-08 00:00:00	2018-11-08 00:00:00	2	t	f	f	f
\.


--
-- Data for Name: sys_global_permit_url; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_global_permit_url (id, permit_name, backend_url_reg, module_id) FROM stdin;
3	通用获取权限相关接口（请勿删除）	/admin/rest_rmp/(get_permission_list|get_module_list).*	\N
2	允许进入后台,使用有些通用接口（请勿删除）	/admin/(rmp|page|common_file_rest).*	\N
\.


--
-- Data for Name: sys_log_admin_operate; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_log_admin_operate (id, admin_user_id, user_name, table_name, operate_type, url, primary_id_value, form_body, create_time) FROM stdin;
2000	3	管理员	sys_module_category_rest	update	/admin/sys_module_category_rest/update/1	\N	{"moduleCategoryName":["生产模块"]}	2018-11-08 13:53:55.216
2001	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/1	\N	{"moduleTitle":["产线管理"]}	2018-11-08 13:54:11.301
2002	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/1	\N	{"moduleName":["iot_product_line"]}	2018-11-08 13:55:03.067
2003	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/1	\N	{"moduleUrl":["admin/page/iot_product_line/list"]}	2018-11-08 13:55:09.803
2004	3	管理员	sys_permission_rest	update	/admin/sys_permission_rest/update/15	\N	{"permissionName":["产线模块保存权限"]}	2018-11-08 13:55:24.511
2005	3	管理员	sys_permission_rest	update	/admin/sys_permission_rest/update/17	\N	{"permissionName":["产线模块添加按钮"]}	2018-11-08 13:55:26.202
2006	3	管理员	sys_permission_rest	update	/admin/sys_permission_rest/update/18	\N	{"permissionName":["产线模块(批量)删除权限"]}	2018-11-08 13:55:27.62
2007	3	管理员	sys_permission_rest	update	/admin/sys_permission_rest/update/19	\N	{"permissionName":["产线模块查询权限"]}	2018-11-08 13:55:31.413
2008	3	管理员	sys_permission_rest	update	/admin/sys_permission_rest/update/22	\N	{"permissionName":["测试产线模块disabled"]}	2018-11-08 13:55:35.212
2009	3	管理员	sys_permission_rest	delete	/admin/sys_permission_rest/delete/22	\N	{}	2018-11-08 13:56:14.609
2010	3	管理员	sys_permission_rest	update	/admin/sys_permission_rest/update/15	\N	{"backendUrlReg":["/admin/iot_product_line_rest/(update|save).*"]}	2018-11-08 13:56:43.062
2011	3	管理员	sys_permission_rest	update	/admin/sys_permission_rest/update/18	\N	{"backendUrlReg":["/admin/iot_product_line_rest/(delete|batch_delete).*"]}	2018-11-08 13:56:46.627
2012	3	管理员	sys_permission_rest	update	/admin/sys_permission_rest/update/19	\N	{"backendUrlReg":["/admin/iot_product_line_rest/(search|page|get).*"]}	2018-11-08 13:57:01.516
2013	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/1	\N	{"moduleTitle":["生产管理"]}	2018-11-08 14:06:47.281
2014	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/1	\N	{"moduleName":["iot_org"]}	2018-11-08 14:09:24.712
2015	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/1	\N	{"moduleUrl":["admin/page/iot_org/list"]}	2018-11-08 14:09:38.992
2016	3	管理员	sys_permission_rest	update	/admin/sys_permission_rest/update/19	\N	{"backendUrlReg":["/admin/iot_org_rest/(search|page|get).*"]}	2018-11-08 14:10:31.162
2017	3	管理员	sys_permission_rest	update	/admin/sys_permission_rest/update/18	\N	{"backendUrlReg":["/admin/iot_org_rest/(delete|batch_delete).*"]}	2018-11-08 14:10:36.203
2018	3	管理员	sys_permission_rest	update	/admin/sys_permission_rest/update/15	\N	{"backendUrlReg":["/admin/iot_org_rest/(update|save).*"]}	2018-11-08 14:10:40.395
2019	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/2	\N	{"moduleTitle":["报警管理"]}	2018-11-08 14:11:13.496
2020	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/2	\N	{"moduleTitle":["报警反馈"]}	2018-11-08 14:13:19.273
2021	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/2	\N	{"moduleTitle":["预警反馈"]}	2018-11-08 14:13:35.746
2022	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/2	\N	{"moduleName":["iot_warning_feedback"]}	2018-11-08 14:13:53.87
2023	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/2	\N	{"moduleUrl":["admin/page/iot_warning_feedback_category/list"]}	2018-11-08 14:14:01.971
2024	3	管理员	sys_permission_rest	update	/admin/sys_permission_rest/update/2	\N	{"backendUrlReg":["/admin/iot_warning_feedback_rest/.*"]}	2018-11-08 14:14:45.424
2025	3	管理员	sys_permission_rest	update	/admin/sys_permission_rest/update/2	\N	{"frontAction":["show"]}	2018-11-08 14:14:55.856
2026	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/2	\N	{"moduleUrl":["admin/page/iot_warning_feedback/list"]}	2018-11-08 14:17:33.053
2027	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":["qqq"],"orgStatus":["1"],"orgType":["zx"],"orgLevel":["as"],"orgCountry":["china"],"orgProvince":["hubei"],"orgCity":["wuhan"],"orgLongItude":["111"],"orgDimension":["22"],"orgSerialNum":["1"],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-08 14:21:54.688
2028	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":["qqq"],"orgStatus":["1"],"orgType":["zx"],"orgLevel":["2"],"orgCountry":["china"],"orgProvince":["hubei"],"orgCity":["wuhan"],"orgLongItude":["111"],"orgDimension":["22"],"orgSerialNum":["1"],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-08 14:23:15.576
2029	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":["qqq"],"orgStatus":["1"],"orgType":["zx"],"orgLevel":["2"],"orgCountry":["china"],"orgProvince":["hubei"],"orgCity":["wuhan"],"orgLongItude":["111"],"orgDimension":["22"],"orgSerialNum":["1"],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-08 14:36:12.776
2030	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":["asdasdasd"],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":["qqq"],"orgStatus":["1"],"orgType":["zx"],"orgLevel":["2"],"orgCountry":["china"],"orgProvince":["hubei"],"orgCity":["wuhan"],"orgLongItude":["111"],"orgDimension":["22"],"orgSerialNum":["1"],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-08 14:44:47.904
2031	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["c"],"orgName":["c"],"parentorgId":["qqq"],"orgStatus":["1"],"orgType":["zx"],"orgLevel":["2"],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-08 14:52:40.511
2032	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["q"],"orgName":["q"],"parentorgId":["qqq"],"orgStatus":["1"],"orgType":["zx"],"orgLevel":["2"],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-08 14:59:20.774
2033	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":["asdasdasd"],"orgCode":["q"],"orgName":["q"],"parentorgId":["qqq"],"orgStatus":["1"],"orgType":["zx"],"orgLevel":["2"],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-08 15:01:02.199
2034	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":["qqq"],"orgStatus":["1"],"orgType":["zx"],"orgLevel":["2"],"orgCountry":["china"],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-08 15:05:16.125
2035	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":["qqq"],"orgStatus":["1"],"orgType":["zx"],"orgLevel":["2"],"orgCountry":["china"],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-08 15:09:50.585
2036	3	管理员	sys_admin_user_rest	save	/admin/sys_admin_user_rest/save		{"id":[""],"username":["dp"],"password":["123"],"realName":["dp"],"email":["ddddd"],"telephone":[""],"mobilePhone":[""],"address":[""],"createTime":[""],"updateTime":[""],"roleId":[""],"enabled":["1"],"accountNonExpired":["0"],"accountNonLocked":["0"],"credentialsNonExpired":["0"]}	2018-11-08 15:18:08.382
2037	3	管理员	sys_admin_user_rest	update	/admin/sys_admin_user_rest/update/2000	\N	{"createTime":["2018-11-08 00:00:00"]}	2018-11-08 15:18:18.468
2038	3	管理员	sys_admin_user_rest	update	/admin/sys_admin_user_rest/update/2000	\N	{"updateTime":["2018-11-08 00:00:00"]}	2018-11-08 15:18:20.668
2039	3	管理员	sys_admin_user_rest	update	/admin/sys_admin_user_rest/update/2000	\N	{"roleId":["2"]}	2018-11-08 15:18:37.781
2040	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":["qqq"],"orgStatus":["1"],"orgType":["zx"],"orgLevel":["2"],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-08 16:32:14.981
2041	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":["qqq"],"orgStatus":[""],"orgType":[""],"orgLevel":[""],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-08 16:50:03.86
2042	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":["qqq"],"orgStatus":[""],"orgType":[""],"orgLevel":[""],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-08 16:51:33.712
2043	3	管理员	sys_module_category_rest	save	/admin/sys_module_category_rest/save		{"id":[""],"moduleCategoryName":["预警模块"],"sortNum":["2"]}	2018-11-08 21:46:50.891
2044	3	管理员	sys_module_category_rest	update	/admin/sys_module_category_rest/update/3	\N	{"sortNum":["3"]}	2018-11-08 21:46:58.229
2045	3	管理员	rest_rmp	save_tree_data	/admin/rest_rmp/save_tree_data/1	\N	{"ids[]":["category_1","module_1","permission_17","permission_19","permission_18","permission_15","module_2","permission_2","module_14","permission_13","module_18","permission_23","module_19","permission_24","category_2000","category_3","module_17","permission_21","module_11","module_7","module_5","module_8","module_4","module_20","permission_25"]}	2018-11-08 21:47:48.165
2046	3	管理员	sys_module_rest	save	/admin/sys_module_rest/save		{"id":[""],"moduleCategoryId":["2000"],"moduleTitle":["采集点预警设置"],"moduleName":["iot_point_warning"],"moduleUrl":["admin/page/iot_point_warning/list"],"sortNum":["2"],"ifShow":["1"]}	2018-11-08 21:50:53.946
2047	3	管理员	sys_module_rest	save	/admin/sys_module_rest/save		{"id":[""],"moduleCategoryId":["2000"],"moduleTitle":["预警反馈"],"moduleName":["iot_warning_feedback"],"moduleUrl":["admin/page/iot_warning_feedback/list"],"sortNum":["3"],"ifShow":["1"]}	2018-11-08 21:51:48.657
2048	3	管理员	sys_module_rest	save	/admin/sys_module_rest/save		{"id":[""],"moduleCategoryId":["2000"],"moduleTitle":["预警推送"],"moduleName":["iot_warning_notify"],"moduleUrl":["admin/page/iot_warning_notify/list"],"sortNum":["4"],"ifShow":["1"]}	2018-11-08 21:55:42.319
2049	3	管理员	sys_module_rest	save	/admin/sys_module_rest/save		{"id":[""],"moduleCategoryId":["2000"],"moduleTitle":["预警记录"],"moduleName":["iot_warning_record"],"moduleUrl":["admin/page/iot_warning_record/list"],"sortNum":["5"],"ifShow":["1"]}	2018-11-08 21:56:29.101
2050	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/2	\N	{"moduleTitle":["采集点"]}	2018-11-08 21:58:09.53
2051	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/2	\N	{"moduleName":["iot_collection_point"]}	2018-11-08 21:58:44.195
2052	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/2	\N	{"moduleUrl":["admin/page/iot_collection_point/list"]}	2018-11-08 21:59:04.51
2053	3	管理员	sys_module_rest	delete	/admin/sys_module_rest/delete/14	\N	{}	2018-11-08 21:59:17.171
2054	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/18	\N	{"moduleTitle":["采集方式"]}	2018-11-08 21:59:43.572
2055	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/18	\N	{"moduleName":["iot_collection_mode"]}	2018-11-08 22:00:05.863
2056	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/18	\N	{"moduleUrl":["admin/page/iot_collection_mode/list"]}	2018-11-08 22:00:20.754
2057	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/19	\N	{"moduleTitle":["设备管理"]}	2018-11-08 22:02:33.702
2058	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/19	\N	{"moduleName":["iot_equipment"]}	2018-11-08 22:03:20.489
2059	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/19	\N	{"moduleUrl":["admin/page/iot_equipment/list"]}	2018-11-08 22:03:38.082
2060	3	管理员	sys_module_rest	save	/admin/sys_module_rest/save		{"id":[""],"moduleCategoryId":["1"],"moduleTitle":["设备文件"],"moduleName":["iot_equipment_file"],"moduleUrl":["admin/page/iot_equipment_file/list"],"sortNum":["6"],"ifShow":["1"]}	2018-11-08 22:06:35.649
2061	3	管理员	sys_module_rest	save	/admin/sys_module_rest/save		{"id":[""],"moduleCategoryId":["1"],"moduleTitle":["设备类型"],"moduleName":["iot_equipment_type"],"moduleUrl":["admin/page/iot_equipment_type/list"],"sortNum":["7"],"ifShow":["1"]}	2018-11-08 22:07:16.672
2062	3	管理员	sys_module_rest	save	/admin/sys_module_rest/save		{"id":[""],"moduleCategoryId":["1"],"moduleTitle":["产线管理"],"moduleName":["iot_product_line"],"moduleUrl":["admin/page/iot_product_line/list"],"sortNum":["8"],"ifShow":["1"]}	2018-11-08 22:08:55.216
2063	3	管理员	sys_module_rest	save	/admin/sys_module_rest/save		{"id":[""],"moduleCategoryId":["1"],"moduleTitle":["车间管理"],"moduleName":["iot_work_shop"],"moduleUrl":["admin/page/iot_work_shop/list"],"sortNum":["9"],"ifShow":["1"]}	2018-11-08 22:09:34.054
2064	3	管理员	sys_module_rest	update	/admin/sys_module_rest/update/1	\N	{"moduleTitle":["组织管理"]}	2018-11-08 22:10:05.979
2065	3	管理员	rest_rmp	save_tree_data	/admin/rest_rmp/save_tree_data/1	\N	{"ids[]":["category_1","module_1","permission_17","permission_19","permission_18","permission_15","module_2","permission_2","module_18","permission_23","module_19","permission_24","module_2004","module_2005","module_2006","module_2007","category_2000","module_2000","module_2001","module_2002","module_2003","category_3","module_17","permission_21","module_11","module_7","module_5","module_8","module_4","module_20","permission_25"]}	2018-11-08 22:10:40.197
2066	3	管理员	sys_permission_rest	save	/admin/sys_permission_rest/save	2	{"id":["2"],"permissionName":["查询权限"],"filterPlatform":["backend"],"backendUrlReg":["/admin/iot_collection_point_rest/.*"],"frontDom":[""],"frontAction":["show"],"moduleId":["2"]}	2018-11-08 22:13:11.994
2067	3	管理员	sys_permission_rest	update	/admin/sys_permission_rest/update/2	\N	{"permissionName":["全部权限"]}	2018-11-08 22:13:48.102
2068	3	管理员	sys_permission_rest	save	/admin/sys_permission_rest/save	23	{"id":["23"],"permissionName":["采集方式全部权限"],"filterPlatform":["front_backend"],"backendUrlReg":["/admin/iot_collection_mode_rest/.*"],"frontDom":[""],"frontAction":["show"],"moduleId":["18"]}	2018-11-08 22:14:32.128
2069	3	管理员	sys_permission_rest	save	/admin/sys_permission_rest/save	24	{"id":["24"],"permissionName":["设备管理全部权限"],"filterPlatform":["front_backend"],"backendUrlReg":["/admin/iot_equipment_rest/.*"],"frontDom":[""],"frontAction":["show"],"moduleId":["19"]}	2018-11-08 22:15:06.753
2070	3	管理员	sys_permission_rest	save	/admin/sys_permission_rest/save		{"id":[""],"permissionName":["设备文件全部权限"],"filterPlatform":["front_backend"],"backendUrlReg":["/admin/iot_equipment_file_rest/.*"],"frontDom":[""],"frontAction":["show"],"moduleId":["2004"]}	2018-11-08 22:16:06.787
2071	3	管理员	sys_permission_rest	save	/admin/sys_permission_rest/save		{"id":[""],"permissionName":["设备类型全部权限"],"filterPlatform":["front_backend"],"backendUrlReg":["/admin/iot_equipment_type_rest/.*"],"frontDom":[""],"frontAction":["show"],"moduleId":["2005"]}	2018-11-08 22:16:34.058
2072	3	管理员	sys_permission_rest	save	/admin/sys_permission_rest/save		{"id":[""],"permissionName":["产线管理全部权限"],"filterPlatform":["front_backend"],"backendUrlReg":["/admin/iot_product_line_rest/.*"],"frontDom":[""],"frontAction":["show"],"moduleId":["2006"]}	2018-11-08 22:17:06.776
2073	3	管理员	sys_permission_rest	save	/admin/sys_permission_rest/save		{"id":[""],"permissionName":["车间管理全部权限"],"filterPlatform":["front_backend"],"backendUrlReg":["/admin/iot_work_shop_rest/.*"],"frontDom":[""],"frontAction":["show"],"moduleId":["2007"]}	2018-11-08 22:18:00.829
2074	3	管理员	sys_permission_rest	save	/admin/sys_permission_rest/save		{"id":[""],"permissionName":["采集点预警全部权限"],"filterPlatform":["front_backend"],"backendUrlReg":["/admin/iot_point_warning_rest/.*"],"frontDom":[""],"frontAction":["show"],"moduleId":["2000"]}	2018-11-08 22:18:47.884
2075	3	管理员	sys_permission_rest	save	/admin/sys_permission_rest/save		{"id":[""],"permissionName":["预警反馈全部权限"],"filterPlatform":["front_backend"],"backendUrlReg":["/admin/iot_warning_feedback_rest/.*"],"frontDom":[""],"frontAction":["show"],"moduleId":["2001"]}	2018-11-08 22:19:25.968
2076	3	管理员	sys_permission_rest	save	/admin/sys_permission_rest/save		{"id":[""],"permissionName":["预警推送全部权限"],"filterPlatform":["front_backend"],"backendUrlReg":["/admin/iot_warning_notify_rest/.*"],"frontDom":[""],"frontAction":["show"],"moduleId":["2002"]}	2018-11-08 22:19:58.532
2077	3	管理员	sys_permission_rest	save	/admin/sys_permission_rest/save		{"id":[""],"permissionName":["预警记录全部权限"],"filterPlatform":["front_backend"],"backendUrlReg":["/admin/iot_warning_record_rest/.*"],"frontDom":[""],"frontAction":["show"],"moduleId":["2003"]}	2018-11-08 22:20:40.013
2078	3	管理员	rest_rmp	save_tree_data	/admin/rest_rmp/save_tree_data/1	\N	{"ids[]":["category_1","module_1","permission_17","permission_19","permission_18","permission_15","module_2","permission_2","module_18","permission_23","module_19","permission_24","module_2004","permission_2000","module_2005","permission_2001","module_2006","permission_2002","module_2007","permission_2003","category_2000","module_2000","permission_2004","module_2001","permission_2005","module_2002","permission_2006","module_2003","permission_2007","category_3","module_17","permission_21","module_11","module_7","module_5","module_8","module_4","module_20","permission_25"]}	2018-11-08 22:21:39.953
2079	3	管理员	rest_rmp	save_tree_data	/admin/rest_rmp/save_tree_data/1	\N	{"ids[]":["category_1","module_1","permission_17","permission_19","permission_18","permission_15","module_2","permission_2","module_18","permission_23","module_19","permission_24","module_2004","permission_2000","module_2005","permission_2001","module_2006","permission_2002","module_2007","permission_2003","category_2000","module_2000","permission_2004","module_2001","permission_2005","module_2002","permission_2006","module_2003","permission_2007","category_3","module_17","permission_21","module_11","module_7","module_5","module_8","module_4","module_20","permission_25"]}	2018-11-08 22:22:44.728
2080	3	管理员	iot_org_rest	update	/admin/iot_org_rest/update/49574b1a-ebb6-458a-a099-7c52f0c43826	\N	{"orgStatus":["1"]}	2018-11-09 00:38:00.624
2081	3	管理员	iot_collection_point_rest	save	/admin/iot_collection_point_rest/save	\N	{"collectionPointId":[""],"equipmentCollectionId":[""],"collectionPointName":["a"],"collectionPointType":[""],"collectionPointRate":["111"],"collectionPointIp":[""],"collectionPointDataType":[""],"collectionPointDataProcess":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-09 09:04:41.372
2082	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":[""],"orgStatus":[""],"orgType":[""],"orgLevel":[""],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-09 09:40:43.961
2083	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":[""],"orgStatus":[""],"orgType":[""],"orgLevel":[""],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-09 09:41:43.167
2084	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":[""],"orgStatus":[""],"orgType":[""],"orgLevel":[""],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-09 09:46:09.198
2085	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":[""],"orgStatus":[""],"orgType":[""],"orgLevel":[""],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-09 09:59:24.707
2086	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":[""],"orgStatus":[""],"orgType":[""],"orgLevel":[""],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-09 10:02:44.858
2087	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":[""],"orgStatus":[""],"orgType":[""],"orgLevel":[""],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-09 10:07:15.406
2088	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":[""],"orgStatus":[""],"orgType":[""],"orgLevel":[""],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-09 10:08:11.779
2089	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":[""],"orgStatus":[""],"orgType":[""],"orgLevel":[""],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-09 10:08:55.282
2090	3	管理员	iot_org_rest	save	/admin/iot_org_rest/save	\N	{"orgId":[""],"orgCode":["aaa"],"orgName":["dp"],"parentorgId":[""],"orgStatus":[""],"orgType":[""],"orgLevel":[""],"orgCountry":[""],"orgProvince":[""],"orgCity":[""],"orgLongItude":[""],"orgDimension":[""],"orgSerialNum":[""],"remarks":[""],"creationTime":[""],"creationUser":[""],"updateTime":[""],"updateUser":[""],"spare1":[""],"spare2":[""],"spare3":[""]}	2018-11-09 10:13:41.029
\.


--
-- Data for Name: sys_module; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_module (id, module_name, module_url, module_category_id, sort_num, module_title, if_show) FROM stdin;
17	sys		3	-1	系统表权限载体（请勿删除）	\N
11	sys_role	admin/page/sys_role/list	3	1	角色管理	t
7	sys_admin_user	admin/page/sys_admin_user/list	3	2	管理员	t
5	sys_module_category	admin/page/sys_module_category/list	3	3	菜单管理	t
8	sys_global_permit_url	admin/page/sys_global_permit_url/list	3	6	全局地址过滤	t
4	sys_log_admin_operate	admin/page/sys_log_admin_operate/list	3	7	系统日志	t
20	dict	admin/page/dict/list	3	10	字典配置	t
2000	iot_point_warning	admin/page/iot_point_warning/list	2000	2	采集点预警设置	t
2001	iot_warning_feedback	admin/page/iot_warning_feedback/list	2000	3	预警反馈	t
2002	iot_warning_notify	admin/page/iot_warning_notify/list	2000	4	预警推送	t
2003	iot_warning_record	admin/page/iot_warning_record/list	2000	5	预警记录	t
2	iot_collection_point	admin/page/iot_collection_point/list	1	2	采集点	t
18	iot_collection_mode	admin/page/iot_collection_mode/list	1	4	采集方式	t
19	iot_equipment	admin/page/iot_equipment/list	1	5	设备管理	t
2004	iot_equipment_file	admin/page/iot_equipment_file/list	1	6	设备文件	t
2005	iot_equipment_type	admin/page/iot_equipment_type/list	1	7	设备类型	t
2006	iot_product_line	admin/page/iot_product_line/list	1	8	产线管理	t
2007	iot_work_shop	admin/page/iot_work_shop/list	1	9	车间管理	t
1	iot_org	admin/page/iot_org/list	1	1	组织管理	t
\.


--
-- Data for Name: sys_module_category; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_module_category (id, module_category_name, sort_num) FROM stdin;
1	生产模块	1
2000	预警模块	2
3	系统模块	3
\.


--
-- Data for Name: sys_permission; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_permission (id, filter_platform, permission_name, backend_url_reg, front_dom, front_action, module_id) FROM stdin;
13	backend	全类型测试	/admin/all_type_rest/.*	\N		14
25	front_backend	字典全部权限	/admin/dict_rest/.*		show	20
21	backend	所有系统表的所有权限(请勿删除)	/admin/(rest_rmp|sys_[a-z_]+_rest)/.*		show	17
17	front	产线模块添加按钮		.security_list_query_operate_add_news	show	1
19	backend	产线模块查询权限	/admin/iot_org_rest/(search|page|get).*			1
18	front_backend	产线模块(批量)删除权限	/admin/iot_org_rest/(delete|batch_delete).*	.security_list_table_operate_del,.security_list_query_operate_del_all	show	1
15	front_backend	产线模块保存权限	/admin/iot_org_rest/(update|save).*	.security_edit_form_operate_save	show	1
2	backend	全部权限	/admin/iot_collection_point_rest/.*		show	2
23	front_backend	采集方式全部权限	/admin/iot_collection_mode_rest/.*		show	18
24	front_backend	设备管理全部权限	/admin/iot_equipment_rest/.*		show	19
2000	front_backend	设备文件全部权限	/admin/iot_equipment_file_rest/.*		show	2004
2001	front_backend	设备类型全部权限	/admin/iot_equipment_type_rest/.*		show	2005
2002	front_backend	产线管理全部权限	/admin/iot_product_line_rest/.*		show	2006
2003	front_backend	车间管理全部权限	/admin/iot_work_shop_rest/.*		show	2007
2004	front_backend	采集点预警全部权限	/admin/iot_point_warning_rest/.*		show	2000
2005	front_backend	预警反馈全部权限	/admin/iot_warning_feedback_rest/.*		show	2001
2006	front_backend	预警推送全部权限	/admin/iot_warning_notify_rest/.*		show	2002
2007	front_backend	预警记录全部权限	/admin/iot_warning_record_rest/.*		show	2003
\.


--
-- Data for Name: sys_role; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_role (id, role_name) FROM stdin;
1	超级管理员
2	测试账号
\.


--
-- Data for Name: sys_role_module_permission; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sys_role_module_permission (id, role_id, module_id, permission_id) FROM stdin;
49	2	18	\N
50	2	19	\N
51	2	1	15
52	2	1	17
53	2	1	18
54	2	1	19
55	2	1	22
2059	1	17	21
2060	1	11	\N
2061	1	7	\N
2062	1	5	\N
2063	1	8	\N
2064	1	4	\N
2065	1	20	25
2066	1	2000	2004
2067	1	2001	2005
2068	1	2002	2006
2069	1	2003	2007
2070	1	2	2
2071	1	18	23
2072	1	19	24
2073	1	2004	2000
2074	1	2005	2001
2075	1	2006	2002
2076	1	2007	2003
2077	1	1	17
2078	1	1	19
2079	1	1	18
2080	1	1	15
\.


--
-- Name: chunk_constraint_name; Type: SEQUENCE SET; Schema: _timescaledb_catalog; Owner: postgres
--

SELECT pg_catalog.setval('_timescaledb_catalog.chunk_constraint_name', 2, true);


--
-- Name: chunk_id_seq; Type: SEQUENCE SET; Schema: _timescaledb_catalog; Owner: postgres
--

SELECT pg_catalog.setval('_timescaledb_catalog.chunk_id_seq', 22, true);


--
-- Name: dimension_id_seq; Type: SEQUENCE SET; Schema: _timescaledb_catalog; Owner: postgres
--

SELECT pg_catalog.setval('_timescaledb_catalog.dimension_id_seq', 15, true);


--
-- Name: dimension_slice_id_seq; Type: SEQUENCE SET; Schema: _timescaledb_catalog; Owner: postgres
--

SELECT pg_catalog.setval('_timescaledb_catalog.dimension_slice_id_seq', 22, true);


--
-- Name: hypertable_id_seq; Type: SEQUENCE SET; Schema: _timescaledb_catalog; Owner: postgres
--

SELECT pg_catalog.setval('_timescaledb_catalog.hypertable_id_seq', 15, true);


--
-- Name: bgw_job_id_seq; Type: SEQUENCE SET; Schema: _timescaledb_config; Owner: postgres
--

SELECT pg_catalog.setval('_timescaledb_config.bgw_job_id_seq', 1000, false);


--
-- Name: dict_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.dict_id_seq', 2000, false);


--
-- Name: sys_admin_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_admin_user_id_seq', 2000, true);


--
-- Name: sys_global_permit_url_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_global_permit_url_id_seq', 2000, false);


--
-- Name: sys_log_admin_operate_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_log_admin_operate_id_seq', 2090, true);


--
-- Name: sys_module_category_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_module_category_id_seq', 2000, true);


--
-- Name: sys_module_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_module_id_seq', 2007, true);


--
-- Name: sys_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_permission_id_seq', 2007, true);


--
-- Name: sys_role_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_role_id_seq', 2000, false);


--
-- Name: sys_role_module_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sys_role_module_permission_id_seq', 2080, true);


--
-- Name: dict dict_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.dict
    ADD CONSTRAINT dict_pkey PRIMARY KEY (id);


--
-- Name: iot_button iot_button_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_button
    ADD CONSTRAINT iot_button_pkey PRIMARY KEY (button_id);


--
-- Name: iot_collection_mode iot_collection_mode_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_collection_mode
    ADD CONSTRAINT iot_collection_mode_pkey PRIMARY KEY (collection_mode_id);


--
-- Name: iot_collection_point iot_collection_point_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_collection_point
    ADD CONSTRAINT iot_collection_point_pkey PRIMARY KEY (collection_point_id);


--
-- Name: iot_dictionary_item iot_dictionary_item_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_dictionary_item
    ADD CONSTRAINT iot_dictionary_item_pkey PRIMARY KEY (item_id);


--
-- Name: iot_dictionary_type iot_dictionary_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_dictionary_type
    ADD CONSTRAINT iot_dictionary_type_pkey PRIMARY KEY (type_id);


--
-- Name: iot_equipment_collection iot_equipment_collection_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_equipment_collection
    ADD CONSTRAINT iot_equipment_collection_pkey PRIMARY KEY (equipment_collection_id);


--
-- Name: iot_equipment_file iot_equipment_file_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_equipment_file
    ADD CONSTRAINT iot_equipment_file_pkey PRIMARY KEY (equipment_file_id);


--
-- Name: iot_equipment iot_equipment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_equipment
    ADD CONSTRAINT iot_equipment_pkey PRIMARY KEY (equipment_id);


--
-- Name: iot_equipment_type iot_equipment_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_equipment_type
    ADD CONSTRAINT iot_equipment_type_pkey PRIMARY KEY (equipment_type_id);


--
-- Name: iot_member iot_member_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_member
    ADD CONSTRAINT iot_member_pkey PRIMARY KEY (user_id);


--
-- Name: iot_menu iot_menu_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_menu
    ADD CONSTRAINT iot_menu_pkey PRIMARY KEY (menu_id);


--
-- Name: iot_org iot_org_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_org
    ADD CONSTRAINT iot_org_pkey PRIMARY KEY (org_id);


--
-- Name: iot_point_warning iot_point_warning_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_point_warning
    ADD CONSTRAINT iot_point_warning_pkey PRIMARY KEY (point_warning_id);


--
-- Name: iot_product_line iot_product_line_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_product_line
    ADD CONSTRAINT iot_product_line_pkey PRIMARY KEY (product_line_id);


--
-- Name: iot_role_auth iot_role_auth_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_role_auth
    ADD CONSTRAINT iot_role_auth_pkey PRIMARY KEY (role_auth_id);


--
-- Name: iot_role iot_role_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_role
    ADD CONSTRAINT iot_role_pkey PRIMARY KEY (role_id);


--
-- Name: iot_user_org iot_user_org_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_user_org
    ADD CONSTRAINT iot_user_org_pkey PRIMARY KEY (user_org_id);


--
-- Name: iot_warning_feedback iot_warning_feedback_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_warning_feedback
    ADD CONSTRAINT iot_warning_feedback_pkey PRIMARY KEY (warning_feedback_id);


--
-- Name: iot_warning_notify iot_warning_notify_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_warning_notify
    ADD CONSTRAINT iot_warning_notify_pkey PRIMARY KEY (warning_notify_id);


--
-- Name: iot_warning_record iot_warning_record_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_warning_record
    ADD CONSTRAINT iot_warning_record_pkey PRIMARY KEY (warning_record_id);


--
-- Name: iot_work_shop iot_work_shop_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_work_shop
    ADD CONSTRAINT iot_work_shop_pkey PRIMARY KEY (work_shop_id);


--
-- Name: sys_admin_user sys_admin_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_admin_user
    ADD CONSTRAINT sys_admin_user_pkey PRIMARY KEY (id);


--
-- Name: sys_global_permit_url sys_global_permit_url_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_global_permit_url
    ADD CONSTRAINT sys_global_permit_url_pkey PRIMARY KEY (id);


--
-- Name: sys_log_admin_operate sys_log_admin_operate_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_log_admin_operate
    ADD CONSTRAINT sys_log_admin_operate_pkey PRIMARY KEY (id);


--
-- Name: sys_module_category sys_module_category_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_module_category
    ADD CONSTRAINT sys_module_category_pkey PRIMARY KEY (id);


--
-- Name: sys_module sys_module_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_module
    ADD CONSTRAINT sys_module_pkey PRIMARY KEY (id);


--
-- Name: sys_permission sys_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_permission
    ADD CONSTRAINT sys_permission_pkey PRIMARY KEY (id);


--
-- Name: sys_role_module_permission sys_role_module_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_role_module_permission
    ADD CONSTRAINT sys_role_module_permission_pkey PRIMARY KEY (id);


--
-- Name: sys_role sys_role_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sys_role
    ADD CONSTRAINT sys_role_pkey PRIMARY KEY (id);


--
-- Name: dict_code_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX dict_code_index ON public.dict USING btree (code);


--
-- Name: iot_button iot_button_menu_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_button
    ADD CONSTRAINT iot_button_menu_id_fkey FOREIGN KEY (menu_id) REFERENCES public.iot_menu(menu_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_collection_point iot_collection_point_equipment_collection_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_collection_point
    ADD CONSTRAINT iot_collection_point_equipment_collection_id_fkey FOREIGN KEY (equipment_collection_id) REFERENCES public.iot_equipment_collection(equipment_collection_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_dictionary_item iot_dictionary_item_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_dictionary_item
    ADD CONSTRAINT iot_dictionary_item_type_id_fkey FOREIGN KEY (type_id) REFERENCES public.iot_dictionary_type(type_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_equipment_collection iot_equipment_collection_collection_mode_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_equipment_collection
    ADD CONSTRAINT iot_equipment_collection_collection_mode_id_fkey FOREIGN KEY (collection_mode_id) REFERENCES public.iot_collection_mode(collection_mode_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_equipment_collection iot_equipment_collection_equipment_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_equipment_collection
    ADD CONSTRAINT iot_equipment_collection_equipment_id_fkey FOREIGN KEY (equipment_id) REFERENCES public.iot_equipment(equipment_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_equipment iot_equipment_equipment_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_equipment
    ADD CONSTRAINT iot_equipment_equipment_type_id_fkey FOREIGN KEY (equipment_type_id) REFERENCES public.iot_equipment_type(equipment_type_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_equipment_file iot_equipment_file_equipment_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_equipment_file
    ADD CONSTRAINT iot_equipment_file_equipment_id_fkey FOREIGN KEY (equipment_id) REFERENCES public.iot_equipment(equipment_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_equipment iot_equipment_product_line_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_equipment
    ADD CONSTRAINT iot_equipment_product_line_id_fkey FOREIGN KEY (product_line_id) REFERENCES public.iot_product_line(product_line_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_member iot_member_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_member
    ADD CONSTRAINT iot_member_role_id_fkey FOREIGN KEY (role_id) REFERENCES public.iot_role(role_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_point_warning iot_point_warning_collection_point_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_point_warning
    ADD CONSTRAINT iot_point_warning_collection_point_id_fkey FOREIGN KEY (collection_point_id) REFERENCES public.iot_collection_point(collection_point_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_product_line iot_product_line_work_shop_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_product_line
    ADD CONSTRAINT iot_product_line_work_shop_id_fkey FOREIGN KEY (work_shop_id) REFERENCES public.iot_work_shop(work_shop_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_role_auth iot_role_auth_menu_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_role_auth
    ADD CONSTRAINT iot_role_auth_menu_id_fkey FOREIGN KEY (menu_id) REFERENCES public.iot_menu(menu_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_role_auth iot_role_auth_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_role_auth
    ADD CONSTRAINT iot_role_auth_role_id_fkey FOREIGN KEY (role_id) REFERENCES public.iot_role(role_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_user_org iot_user_org_org_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_user_org
    ADD CONSTRAINT iot_user_org_org_id_fkey FOREIGN KEY (org_id) REFERENCES public.iot_org(org_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_user_org iot_user_org_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_user_org
    ADD CONSTRAINT iot_user_org_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.iot_member(user_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_warning_feedback iot_warning_feedback_warning_record_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_warning_feedback
    ADD CONSTRAINT iot_warning_feedback_warning_record_id_fkey FOREIGN KEY (warning_record_id) REFERENCES public.iot_warning_record(warning_record_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- Name: iot_warning_notify iot_warning_notify_collection_point_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.iot_warning_notify
    ADD CONSTRAINT iot_warning_notify_collection_point_id_fkey FOREIGN KEY (collection_point_id) REFERENCES public.iot_point_warning(point_warning_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


--
-- PostgreSQL database dump complete
--

